JSON Decoder Plugin Array Support

By default, arrays with the object are not supported (with the exception of size 1 arrays, which are expanded inline). Arrays at the outermost layer are expanded automatically into additional rows of data in your transformation.

The example below shows an array (one row of JSON).

When the above array is decoded, five output rows will be generated.

Because only outermost arrays are expanded, two JSON decoders can be chained together to extract array information from more complex JSON structures. The first JSON decoder strips all elements to fields, and the second JSON decoder expands the array from one field. For example, these arrays:

Result in this output:

• Using the JSON Decoder Plugin
  • JSON Decoder Plugin Options
  • JSON Decoder Plugin Array Support
  • Running the Scripts Using Pan